﻿CREATE view [dbo].[ManufacturersAboveAverage] as
select *
from Manufacturers
where SchemaCount>(select avg(SchemaCount) from Manufacturers)
